let
    Source = Excel.Workbook(Web.Contents("<sharepoint url goes here>"), null, true),
    Source_Table = Source{[Item="AccountsTypes",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Source_Table,{{"AccountType", type text}, {"AccountTypeName", type text}})
in
    #"Changed Type"